﻿CREATE TABLE [dbo].[Course] (
    [CourseID]          INT            IDENTITY (1, 1) NOT NULL,
    [CourseName]        NVARCHAR (50)  NOT NULL,
    [CourseNumber]      INT            NOT NULL,
    [CourseDescription] NVARCHAR (500) NULL,
    [Teacher]           INT            NOT NULL,
    [Department]        INT            NOT NULL
);

